package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:29
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysSerialCodeDAOQueryBean extends BaseQueryBean {
    public SysSerialCodeDAOQueryBean() {
        super();
    }

    public SysSerialCodeDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysSerialCodeDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.Id, "id");
        }
    }

    public void addCodeTemplateSelectProperty() {
        addCodeTemplateSelectProperty("codeTemplate");
    }

    public void addCodeTemplateSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.CodeTemplate, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.CodeTemplate, "codeTemplate");
        }
    }

    public void addCodeTypeSelectProperty() {
        addCodeTypeSelectProperty("codeType");
    }

    public void addCodeTypeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.CodeType, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.CodeType, "codeType");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.Remarks, "remarks");
        }
    }

    public void addSerialNumberSelectProperty() {
        addSerialNumberSelectProperty("serialNumber");
    }

    public void addSerialNumberSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.SerialNumber, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.SerialNumber, "serialNumber");
        }
    }

    public void addSerialNumberIncrementSelectProperty() {
        addSerialNumberIncrementSelectProperty("serialNumberIncrement");
    }

    public void addSerialNumberIncrementSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.SerialNumberIncrement, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.SerialNumberIncrement,
                "serialNumberIncrement");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.Status, "status");
        }
    }

    public void addSerialNumberFormatSelectProperty() {
        addSerialNumberFormatSelectProperty("serialNumberFormat");
    }

    public void addSerialNumberFormatSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysSerialCodeDAO.SerialNumberFormat, aAlias);
        } else {
            addSelectProperty(ISysSerialCodeDAO.SerialNumberFormat,
                "serialNumberFormat");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addCodeTemplateSelectProperty();

        addCodeTypeSelectProperty();

        addRemarksSelectProperty();

        addSerialNumberSelectProperty();

        addSerialNumberIncrementSelectProperty();

        addStatusSelectProperty();

        addSerialNumberFormatSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysSerialCodeDAOQueryBean> {
        protected Criteria(SysSerialCodeDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysSerialCodeDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysSerialCodeDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.Id + " is not null AND " +
                ISysSerialCodeDAO.Id + " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.Id + " is null OR " +
                ISysSerialCodeDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " is null OR " +
                ISysSerialCodeDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Id + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysSerialCodeDAO.Id + " between", value1, value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysSerialCodeDAO.Id + " between", value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysSerialCodeDAO.Id + " not between", value1, value2,
                "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysSerialCodeDAO.Id + " not between", value1, value2,
                "id");

            return this;
        }

        public Criteria andCodeTemplateIsNull() {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " is null");

            return this;
        }

        public Criteria andCodeTemplateIsNotNull() {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " is not null");

            return this;
        }

        public Criteria andCodeTemplateIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " is not null AND " +
                ISysSerialCodeDAO.CodeTemplate + " <> ''");

            return this;
        }

        public Criteria andCodeTemplateIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.CodeTemplate + " is null OR " +
                ISysSerialCodeDAO.CodeTemplate + " = '')");

            return this;
        }

        public Criteria andCodeTemplateEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " = ", value,
                "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeTemplate);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTemplateEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateNotEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " <>", value,
                "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateNotEqualToOrIsNull(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " is null OR " +
                ISysSerialCodeDAO.CodeTemplate + " <>", value, "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeTemplate);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTemplateNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateGreaterThan(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " >", value,
                "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeTemplate);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTemplateGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateGreaterThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " >=", value,
                "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeTemplate);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTemplateGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateLessThan(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " <", value,
                "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeTemplate);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTemplateLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateLessThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " <=", value,
                "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeTemplate);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTemplateLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " like",
                buffer.toString(), "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " not like",
                buffer.toString(), "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateIn(List<String> values) {
            if (values.size() == 1) {
                return andCodeTemplateEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.CodeTemplate + " in", values,
                    "codeTemplate");

                return this;
            }
        }

        public Criteria andCodeTemplateNotIn(List<String> values) {
            if (values.size() == 1) {
                return andCodeTemplateNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.CodeTemplate + " not in",
                    values, "codeTemplate");

                return this;
            }
        }

        public Criteria andCodeTemplateIn(String[] values) {
            if (values.length == 1) {
                return andCodeTemplateEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.CodeTemplate + " in",
                    Arrays.asList(values), "codeTemplate");

                return this;
            }
        }

        public Criteria andCodeTemplateNotIn(String[] values) {
            if (values.length == 1) {
                return andCodeTemplateNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.CodeTemplate + " not in",
                    Arrays.asList(values), "codeTemplate");

                return this;
            }
        }

        public Criteria andCodeTemplateIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTemplateNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTemplateBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " between", value1,
                value2, "codeTemplate");

            return this;
        }

        public Criteria andCodeTemplateNotBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.CodeTemplate + " not between",
                value1, value2, "codeTemplate");

            return this;
        }

        public Criteria andCodeTypeIsNull() {
            addCriterion(ISysSerialCodeDAO.CodeType + " is null");

            return this;
        }

        public Criteria andCodeTypeIsNotNull() {
            addCriterion(ISysSerialCodeDAO.CodeType + " is not null");

            return this;
        }

        public Criteria andCodeTypeIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.CodeType + " is not null AND " +
                ISysSerialCodeDAO.CodeType + " <> ''");

            return this;
        }

        public Criteria andCodeTypeIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.CodeType + " is null OR " +
                ISysSerialCodeDAO.CodeType + " = '')");

            return this;
        }

        public Criteria andCodeTypeEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " = ", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeType);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTypeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeNotEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " <>", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeNotEqualToOrIsNull(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " is null OR " +
                ISysSerialCodeDAO.CodeType + " <>", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeType);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTypeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeGreaterThan(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " >", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeType);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTypeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " >=", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeType);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTypeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeLessThan(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " <", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeType);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTypeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeLessThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.CodeType + " <=", value, "codeType");

            return this;
        }

        public Criteria andCodeTypeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.CodeType);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andCodeTypeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.CodeType + " like",
                buffer.toString(), "codeType");

            return this;
        }

        public Criteria andCodeTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.CodeType + " not like",
                buffer.toString(), "codeType");

            return this;
        }

        public Criteria andCodeTypeIn(List<String> values) {
            if (values.size() == 1) {
                return andCodeTypeEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.CodeType + " in", values,
                    "codeType");

                return this;
            }
        }

        public Criteria andCodeTypeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andCodeTypeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.CodeType + " not in", values,
                    "codeType");

                return this;
            }
        }

        public Criteria andCodeTypeIn(String[] values) {
            if (values.length == 1) {
                return andCodeTypeEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.CodeType + " in",
                    Arrays.asList(values), "codeType");

                return this;
            }
        }

        public Criteria andCodeTypeNotIn(String[] values) {
            if (values.length == 1) {
                return andCodeTypeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.CodeType + " not in",
                    Arrays.asList(values), "codeType");

                return this;
            }
        }

        public Criteria andCodeTypeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andCodeTypeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.CodeType + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andCodeTypeBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.CodeType + " between", value1,
                value2, "codeType");

            return this;
        }

        public Criteria andCodeTypeNotBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.CodeType + " not between", value1,
                value2, "codeType");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysSerialCodeDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysSerialCodeDAO.Remarks + " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.Remarks + " is not null AND " +
                ISysSerialCodeDAO.Remarks + " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.Remarks + " is null OR " +
                ISysSerialCodeDAO.Remarks + " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " = ", value, "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " is null OR " +
                ISysSerialCodeDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " >", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " >=", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " <", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Remarks + " <=", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.Remarks + " like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.Remarks + " in", values,
                    "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.Remarks + " not in", values,
                    "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Remarks + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.Remarks + " between", value1,
                value2, "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.Remarks + " not between", value1,
                value2, "remarks");

            return this;
        }

        public Criteria andSerialNumberIsNull() {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " is null");

            return this;
        }

        public Criteria andSerialNumberIsNotNull() {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " is not null");

            return this;
        }

        public Criteria andSerialNumberIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " is not null AND " +
                ISysSerialCodeDAO.SerialNumber + " <> ''");

            return this;
        }

        public Criteria andSerialNumberIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.SerialNumber + " is null OR " +
                ISysSerialCodeDAO.SerialNumber + " = '')");

            return this;
        }

        public Criteria andSerialNumberEqualTo(long value) {
            return andSerialNumberEqualTo(Long.valueOf(value));
        }

        public Criteria andSerialNumberEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " = ", value,
                "serialNumber");

            return this;
        }

        public Criteria andSerialNumberEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumber);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberNotEqualTo(long value) {
            return andSerialNumberNotEqualTo(Long.valueOf(value));
        }

        public Criteria andSerialNumberNotEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " <>", value,
                "serialNumber");

            return this;
        }

        public Criteria andSerialNumberNotEqualToOrIsNull(long value) {
            return andSerialNumberNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andSerialNumberNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " is null OR " +
                ISysSerialCodeDAO.SerialNumber + " <>", value, "serialNumber");

            return this;
        }

        public Criteria andSerialNumberNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumber);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberGreaterThan(long value) {
            return andSerialNumberGreaterThan(Long.valueOf(value));
        }

        public Criteria andSerialNumberGreaterThan(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " >", value,
                "serialNumber");

            return this;
        }

        public Criteria andSerialNumberGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumber);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberGreaterThanOrEqualTo(long value) {
            return andSerialNumberGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andSerialNumberGreaterThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " >=", value,
                "serialNumber");

            return this;
        }

        public Criteria andSerialNumberGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumber);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberLessThan(long value) {
            return andSerialNumberLessThan(Long.valueOf(value));
        }

        public Criteria andSerialNumberLessThan(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " <", value,
                "serialNumber");

            return this;
        }

        public Criteria andSerialNumberLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumber);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberLessThanOrEqualTo(long value) {
            return andSerialNumberLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andSerialNumberLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " <=", value,
                "serialNumber");

            return this;
        }

        public Criteria andSerialNumberLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumber);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberIn(long[] values) {
            if (values.length == 1) {
                return andSerialNumberEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumber + " in", values,
                    "serialNumber");

                return this;
            }
        }

        public Criteria andSerialNumberNotIn(long[] values) {
            if (values.length == 1) {
                return andSerialNumberNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumber + " not in",
                    values, "serialNumber");

                return this;
            }
        }

        public Criteria andSerialNumberIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andSerialNumberEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumber + " in", values,
                    "serialNumber");

                return this;
            }
        }

        public Criteria andSerialNumberNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andSerialNumberNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumber + " not in",
                    values, "serialNumber");

                return this;
            }
        }

        public Criteria andSerialNumberIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andSerialNumberEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumber + " in",
                    Arrays.asList(values), "serialNumber");

                return this;
            }
        }

        public Criteria andSerialNumberNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andSerialNumberNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumber + " not in",
                    Arrays.asList(values), "serialNumber");

                return this;
            }
        }

        public Criteria andSerialNumberIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andSerialNumberNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberBetween(long value1, long value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " between", value1,
                value2, "serialNumber");

            return this;
        }

        public Criteria andSerialNumberBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " between", value1,
                value2, "serialNumber");

            return this;
        }

        public Criteria andSerialNumberNotBetween(long value1, long value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " not between",
                value1, value2, "serialNumber");

            return this;
        }

        public Criteria andSerialNumberNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumber + " not between",
                value1, value2, "serialNumber");

            return this;
        }

        public Criteria andSerialNumberIncrementIsNull() {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " is null");

            return this;
        }

        public Criteria andSerialNumberIncrementIsNotNull() {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                " is not null");

            return this;
        }

        public Criteria andSerialNumberIncrementIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                " is not null AND " + ISysSerialCodeDAO.SerialNumberIncrement +
                " <> ''");

            return this;
        }

        public Criteria andSerialNumberIncrementIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.SerialNumberIncrement +
                " is null OR " + ISysSerialCodeDAO.SerialNumberIncrement +
                " = '')");

            return this;
        }

        public Criteria andSerialNumberIncrementEqualTo(int value) {
            return andSerialNumberIncrementEqualTo(Integer.valueOf(value));
        }

        public Criteria andSerialNumberIncrementEqualTo(java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " = ",
                value, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberIncrement);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberIncrementEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementNotEqualTo(int value) {
            return andSerialNumberIncrementNotEqualTo(Integer.valueOf(value));
        }

        public Criteria andSerialNumberIncrementNotEqualTo(
            java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " <>",
                value, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementNotEqualToOrIsNull(int value) {
            return andSerialNumberIncrementNotEqualToOrIsNull(Integer.valueOf(
                    value));
        }

        public Criteria andSerialNumberIncrementNotEqualToOrIsNull(
            java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                " is null OR " + ISysSerialCodeDAO.SerialNumberIncrement +
                " <>", value, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberIncrement);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberIncrementNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementGreaterThan(int value) {
            return andSerialNumberIncrementGreaterThan(Integer.valueOf(value));
        }

        public Criteria andSerialNumberIncrementGreaterThan(
            java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " >", value,
                "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberIncrement);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberIncrementGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementGreaterThanOrEqualTo(int value) {
            return andSerialNumberIncrementGreaterThanOrEqualTo(Integer.valueOf(
                    value));
        }

        public Criteria andSerialNumberIncrementGreaterThanOrEqualTo(
            java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " >=",
                value, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberIncrement);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberIncrementGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementLessThan(int value) {
            return andSerialNumberIncrementLessThan(Integer.valueOf(value));
        }

        public Criteria andSerialNumberIncrementLessThan(
            java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " <", value,
                "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberIncrement);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberIncrementLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementLessThanOrEqualTo(int value) {
            return andSerialNumberIncrementLessThanOrEqualTo(Integer.valueOf(
                    value));
        }

        public Criteria andSerialNumberIncrementLessThanOrEqualTo(
            java.lang.Integer value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " <=",
                value, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberIncrement);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberIncrementLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementIn(int[] values) {
            if (values.length == 1) {
                return andSerialNumberIncrementEqualTo((java.lang.Integer) values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " in",
                    values, "serialNumberIncrement");

                return this;
            }
        }

        public Criteria andSerialNumberIncrementNotIn(int[] values) {
            if (values.length == 1) {
                return andSerialNumberIncrementNotEqualTo((java.lang.Integer) values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                    " not in", values, "serialNumberIncrement");

                return this;
            }
        }

        public Criteria andSerialNumberIncrementIn(
            List<java.lang.Integer> values) {
            if (values.size() == 1) {
                return andSerialNumberIncrementEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " in",
                    values, "serialNumberIncrement");

                return this;
            }
        }

        public Criteria andSerialNumberIncrementNotIn(
            List<java.lang.Integer> values) {
            if (values.size() == 1) {
                return andSerialNumberIncrementNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                    " not in", values, "serialNumberIncrement");

                return this;
            }
        }

        public Criteria andSerialNumberIncrementIn(java.lang.Integer[] values) {
            if (values.length == 1) {
                return andSerialNumberIncrementEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " in",
                    Arrays.asList(values), "serialNumberIncrement");

                return this;
            }
        }

        public Criteria andSerialNumberIncrementNotIn(
            java.lang.Integer[] values) {
            if (values.length == 1) {
                return andSerialNumberIncrementNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                    " not in", Arrays.asList(values), "serialNumberIncrement");

                return this;
            }
        }

        public Criteria andSerialNumberIncrementIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberIncrementBetween(int value1, int value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " between",
                value1, value2, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementBetween(
            java.lang.Integer value1, java.lang.Integer value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement + " between",
                value1, value2, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementNotBetween(int value1,
            int value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                " not between", value1, value2, "serialNumberIncrement");

            return this;
        }

        public Criteria andSerialNumberIncrementNotBetween(
            java.lang.Integer value1, java.lang.Integer value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumberIncrement +
                " not between", value1, value2, "serialNumberIncrement");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysSerialCodeDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysSerialCodeDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.Status + " is not null AND " +
                ISysSerialCodeDAO.Status + " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.Status + " is null OR " +
                ISysSerialCodeDAO.Status + " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " = ", value, "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " is null OR " +
                ISysSerialCodeDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " >", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " >=", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " <", value, "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.Status + " <=", value, "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.Status + " like", buffer.toString(),
                "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.Status + " not like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.Status + " in", values, "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.Status + " not in", values,
                    "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.Status + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.Status + " between", value1, value2,
                "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysSerialCodeDAO.Status + " not between", value1,
                value2, "status");

            return this;
        }

        public Criteria andSerialNumberFormatIsNull() {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " is null");

            return this;
        }

        public Criteria andSerialNumberFormatIsNotNull() {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " is not null");

            return this;
        }

        public Criteria andSerialNumberFormatIsNotEmpty() {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat +
                " is not null AND " + ISysSerialCodeDAO.SerialNumberFormat +
                " <> ''");

            return this;
        }

        public Criteria andSerialNumberFormatIsEmpty() {
            addCriterion("(" + ISysSerialCodeDAO.SerialNumberFormat +
                " is null OR " + ISysSerialCodeDAO.SerialNumberFormat +
                " = '')");

            return this;
        }

        public Criteria andSerialNumberFormatEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " = ", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberFormat);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberFormatEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatNotEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " <>", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatNotEqualToOrIsNull(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " is null OR " +
                ISysSerialCodeDAO.SerialNumberFormat + " <>", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberFormat);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberFormatNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatGreaterThan(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " >", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberFormat);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberFormatGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatGreaterThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " >=", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberFormat);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberFormatGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatLessThan(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " <", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberFormat);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberFormatLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatLessThanOrEqualTo(String value) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " <=", value,
                "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysSerialCodeDAO.SerialNumberFormat);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSerialNumberFormatLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " like",
                buffer.toString(), "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " not like",
                buffer.toString(), "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatIn(List<String> values) {
            if (values.size() == 1) {
                return andSerialNumberFormatEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " in",
                    values, "serialNumberFormat");

                return this;
            }
        }

        public Criteria andSerialNumberFormatNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSerialNumberFormatNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " not in",
                    values, "serialNumberFormat");

                return this;
            }
        }

        public Criteria andSerialNumberFormatIn(String[] values) {
            if (values.length == 1) {
                return andSerialNumberFormatEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " in",
                    Arrays.asList(values), "serialNumberFormat");

                return this;
            }
        }

        public Criteria andSerialNumberFormatNotIn(String[] values) {
            if (values.length == 1) {
                return andSerialNumberFormatNotEqualTo(values[0]);
            } else {
                addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " not in",
                    Arrays.asList(values), "serialNumberFormat");

                return this;
            }
        }

        public Criteria andSerialNumberFormatIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSerialNumberFormatBetween(String value1,
            String value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " between",
                value1, value2, "serialNumberFormat");

            return this;
        }

        public Criteria andSerialNumberFormatNotBetween(String value1,
            String value2) {
            addCriterion(ISysSerialCodeDAO.SerialNumberFormat + " not between",
                value1, value2, "serialNumberFormat");

            return this;
        }
    }
}
